StockLocateRequestGateway

V8 Message Definiton

Records inserted into this gateway become locate requests and are visible in the StockLocateRequest table.

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	Internal
Product	SRControl
accessType	SELECT,UPDATE(requestQuan),INSERT,DELETE
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
ticker_at	enum - AssetType	PRI	'None'
ticker_ts	enum - TickerSrc	PRI	'None'
ticker_tk	VARCHAR(12)	PRI	''
coreClientFirm	VARCHAR(16)	PRI	''
locateFirm	VARCHAR(6)	PRI	''	locate firm defaults to clientFirmConfigdefaultLocateFirm
locatePool	VARCHAR(16)	PRI	''	locate pool firm granting the locate defaults to clientFirmConfigdefaultLocatePool
requestQuan	INT		0	request quantity
timestamp	DATETIME(6)		'1900-01-01 00:00:00'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
ticker_tk	1
ticker_at	2
ticker_ts	3
coreClientFirm	4
locateFirm	5
locatePool	6

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRControl`.`MsgStockLocateRequestGateway`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `ticker_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a VARCHAR(16) */
    `coreClientFirm` = 'Example_coreClientFirm'
  AND
    /* Replace with a VARCHAR(6) */
    `locateFirm` = 'Example_locateFirm'
  AND
    /* Replace with a VARCHAR(16) */
    `locatePool` = 'Example_locatePool';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRControl`.`MsgStockLocateRequestGateway`(
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `ticker_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */ 
    `ticker_ts`,
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk`,
    /* Replace with a VARCHAR(16) */
    `coreClientFirm`,
    /* Replace with a VARCHAR(6) */
    `locateFirm`,
    /* Replace with a VARCHAR(16) */
    `locatePool`,
    /* Replace with a INT */ 
    `requestQuan`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    'None',
    'None',
    'Example_ticker_tk',
    'Example_coreClientFirm',
    'Example_locateFirm',
    'Example_locatePool',
    5,
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRControl`.`MsgStockLocateRequestGateway` 
WHERE
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `ticker_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a VARCHAR(16) */
    `coreClientFirm` = 'Example_coreClientFirm'
  AND
    /* Replace with a VARCHAR(6) */
    `locateFirm` = 'Example_locateFirm'
  AND
    /* Replace with a VARCHAR(16) */
    `locatePool` = 'Example_locatePool';

Doc Columns Query

SELECT * FROM SRControl.doccolumns WHERE TABLE_NAME='StockLocateRequestGateway' ORDER BY ordinal_position ASC;